# Frierson, Dylan Lab 6
# 1 
USE books;
INSERT INTO publisher VALUES (6, "new publisher", "new publisher", '101-222-8969');
INSERT INTO books VALUES (0944213846, "new book", "2003-04-24", 6, 12.00, 13.00, "THINGS");
INSERT INTO author VALUES ("Z150", "JINKINS", "BOB");
INSERT INTO customers VALUES (1030, "SMITH", "JOHN", "P.O. BOX 221", "MIAMI", "FL", 33101, NULL);
# 2
USE books;
DELETE FROM books WHERE PubID = 6;
DELETE FROM publisher WHERE PubID = 6;
DELETE FROM author WHERE AuthorID = "Z150";
DELETE FROM customers WHERE Customernum = 1030;
# 3 
USE lyric;
UPDATE SalesPeople SET Base = 400.00 WHERE SalesID = 2;
# 4
USE lyric;
UPDATE SalesPeople SET Base = 150.00 WHERE FirstName = "Clint" AND LastName = "Sanchez";
# 5
USE lyric;
UPDATE Members SET WorkPhone = HomePhone WHERE FirstName = "Mary" AND LastName = "Chrisman";
# 6
USE lyric;
UPDATE Titles SET UPC = "4238619983", Genre = "jazz" WHERE Title = "Word Live";
# 7 
USE lyric;
UPDATE Members SET SalesID = 3 WHERE Country = "Canada" AND SalesID = 2;
# 8
USE lyric 
UPDATE SalesPeople SET FirstName = LOWER(FirstName), LastName = LOWER(LastName); 
# 9 
USE crashcourse;
UPDATE customers SET cust_email = "no email" WHERE cust_email IS NULL;
# 10 
USE crashcourse;
UPDATE orderitems SET quantity = quantity + quantity;